-: If you have data on a line chart,
and have the same data on a column chart
and you put them one above the other,
you can see we basically create an area under it.
And this is exactly what the area chart is used for.
Here we have data.
We have three models of phones sold in one year,
second year and third year.
And they were released later on
and I wanna take all the data
and create an advanced area chart
that will display how one phone started out well
but, of course, over time, the sales get a bit lower
but then the next phone launches
and it overtakes the sales.
Okay, let's start creating by inserting an area chart.
I have the area chart selected by default.
I press OK.
And here we have two areas overlapping each other.
I'll Control + V the data.
You can see plenty of data points
and we have three different phones.
Okay, beautiful.
We inserted this area chart.
Now, go to Chart Design, select Data
and deselect one of the years.
We can either do this by clicking on the chart,
clicking on the filter, and deselecting one year here
or simply going to here on the top side, Chart Design.
And we have this option to select data.
If we go to Select Data,
you can see this opens and we can deselect one
of the data points.
Okay, it's just depending
on what is more convenient for you.
I wanted to show you that you can do similar things
in different places in PowerPoint.
Now, make the 2049 phone series data a little transparent.
I would like to know if I click on the left one,
you can see, I would like to see what happens here.
I don't want this to be covered
by since this is a normal area chart
on top of each other, they cover each other.
So I'll click on this one, right click.
I'll format this data series.
I'm going to this bucket, to the filling options.
And it's automatic.
Automatically it sets to a color
but I will select the same thing, a solid fill,
but if I select the solid fill,
I have now also the transparency options.
I need to return to the blue color,
it was the second blue color,
and I need to give it a bit of transparency.
This way, I can see what happens behind.
This is an optional step but I really like to do this
to showcase more information to people
who watch this chart.
Then display vertical grid lines every year.
Delete years completely.
Now, this would be a difficult task.
Look at those data points.
So many of them.
What do we want to do?
We want to go to the years,
and those grid lines, let me select grid lines.
Instead of a primary major horizontal,
I want the vertical ones
but there are so many vertical lines.
I want the vertical units display every one year.
You can see what happened.
Beautiful.
Now we have year number one, year number two,
year number three.
248.
I will delete this completely
because I don't want the legend to be on the bottom.
The legend is okay but I didn't want the axis
to be on the bottom.
Instead, I can simply go to Insert > Shapes.
I can insert the shape and make a completely custom design,
for example, displaying 248.
I will select by Control + A everything.
Going to Home and just making it bigger.
Placing it in the middle,
maybe making this a little like that.
And beautiful, we have something
that displays the years.
I'll press Control + D.
I have a shortcut for recoloring.
And we basically designed some kind of display for our years
for different phones.
Shape Format > Shape Outline.
No outline and everything looks really nice.
I think we completed task number four.
Number five, add years manually.
This is exactly what we wanted to do;.
Since we have no axis,
but we still need to inform people what is going on
in this chart, we needed to display them like that.
Okay, here we would need to explain this is sales in units
or something like that.
Here we would need a title
and this chart would be ready.
In the next lecture, I wanna show you a stacked area chart
that showcases information a little different
because different areas are on top of each other.
So see you there.